﻿CREATE TYPE [flcr].[RESOURCE_UDT] AS  TABLE (
    [RESOURCE_ID]       INT              NULL,
    [AUDIT_USER]        VARCHAR (100)    NULL,
    [AUDIT_DTTM]        DATETIME         NULL,
    [AUDIT_DTTM_TZ]     INT              NULL,
    [AUDIT_MOD_USER]    VARCHAR (100)    NULL,
    [AUDIT_MOD_DTTM]    DATETIME         NULL,
    [AUDIT_MOD_DTTM_TZ] INT              NULL,
    [RLS_MASK]          VARBINARY (1)    NULL,
    [RLS_OWNER]         UNIQUEIDENTIFIER NULL,
    [ACTIVE_FLG]        BIT              NULL,
    [SORT_ORDER]        INT              NULL,
    [RESOURCE_NAME]     VARCHAR (100)    NULL,
    [RESOURCE_EMAIL]    VARCHAR (100)    NULL,
    [RESOURCE_TYPE]     INT              NULL,
    [SUPPLIER_ID]       INT              NULL,
    [SUPPORT_ROLE_ID]   INT              NULL,
    [PARENT_ID]         INT              NULL);

